/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */

package roomarrange;

import com.sun.rave.web.ui.appbase.AbstractSessionBean;
import com.sun.sql.rowset.CachedRowSetXImpl;
import javax.faces.FacesException;

/**
 * <p>Session scope data bean for your application.  Create properties
 *  here to represent cached data that should be made available across
 *  multiple HTTP requests for an individual user.</p>
 *
 * <p>An instance of this class will be created for you automatically,
 * the first time your application evaluates a value binding expression
 * or method binding expression that references a managed bean using
 * this class.</p>
 *
 * @version SessionBean1.java
 * @version Created on 2009-8-25, 10:29:08
 * @author ben
 */

public class SessionBean1 extends AbstractSessionBean {
    // <editor-fold defaultstate="collapsed" desc="Managed Component Definition">

    /**
     * <p>Automatically managed component initialization.  <strong>WARNING:</strong>
     * This method is automatically generated, so any user-specified code inserted
     * here is subject to being replaced.</p>
     */
    private void _init() throws Exception {
        t_usrsetRowSet.setDataSourceName("java:comp/env/jdbc/roomarrange_MySQL");
        t_usrsetRowSet.setCommand("SELECT * FROM t_usrset");
        t_usrsetRowSet.setTableName("t_usrset");
        t_grpsetRowSet.setDataSourceName("java:comp/env/jdbc/roomarrange_MySQL");
        t_grpsetRowSet.setCommand("SELECT * FROM t_grpset");
        t_grpsetRowSet.setTableName("t_grpset");
        t_roomsetRowSet.setDataSourceName("java:comp/env/jdbc/roomarrange_MySQL");
        t_roomsetRowSet.setCommand("SELECT * FROM t_roomset where i_bj<4");
        t_roomsetRowSet.setTableName("t_roomset");
        t_grpsortRowSet.setDataSourceName("java:comp/env/jdbc/roomarrange_MySQL");
        t_grpsortRowSet.setCommand("SELECT * FROM t_grpsort");
        t_grpsortRowSet.setTableName("t_grpsort");
        t_grpusrsRowSet.setDataSourceName("java:comp/env/jdbc/roomarrange_MySQL");
        t_grpusrsRowSet.setCommand("SELECT * FROM t_grpusrs");
        t_grpusrsRowSet.setTableName("t_grpusrs");
        v_grpusrsRowSet.setDataSourceName("java:comp/env/jdbc/roomarrange_MySQL");
        v_grpusrsRowSet.setCommand("SELECT ALL v_grpusrs.usr_id, v_grpusrs.usr_name, v_grpusrs.grp_id, v_grpusrs.grp_name, v_grpusrs.ileader  FROM v_grpusrs WHERE v_grpusrs.grp_id = ?");
        v_grpusrsRowSet.setTableName("v_grpusrs");
        t_grpusrsRowSet1.setDataSourceName("java:comp/env/jdbc/roomarrange_MySQL");
        t_grpusrsRowSet1.setCommand("SELECT ALL t_grpusrs.igrpid, t_grpusrs.iusrid, t_grpusrs.ileader  FROM t_grpusrs WHERE t_grpusrs.igrpid = ?          AND t_grpusrs.iusrid = ?");
        t_grpusrsRowSet1.setTableName("t_grpusrs");
        t_roomsortRowSet.setDataSourceName("java:comp/env/jdbc/roomarrange_MySQL");
        t_roomsortRowSet.setCommand("SELECT * FROM t_roomsort");
        t_roomsortRowSet.setTableName("t_roomsort");
        t_grpsetRowSet1.setDataSourceName("java:comp/env/jdbc/roomarrange_MySQL");
        t_grpsetRowSet1.setCommand("SELECT ALL t_grpset.i_id, t_grpset.cname  FROM t_grpset WHERE t_grpset.i_bj = 1");
        t_grpsetRowSet1.setTableName("t_grpset");
        t_meetingsRowSet.setDataSourceName("java:comp/env/jdbc/roomarrange_MySQL");
        t_meetingsRowSet.setCommand("SELECT ALL t_meetings.i_id, t_meetings.sdate, t_meetings.stime, t_meetings.edate, t_meetings.etime, t_meetings.cname, t_meetings.iroomid, t_meetings.ihost, t_meetings.cinitdept, t_meetings.cabstract, t_meetings.copinion, t_meetings.cnotice, t_meetings.inetdown, t_meetings.ivideo, t_meetings.iusrid, t_meetings.iconfirmid, t_meetings.istatus  FROM t_meetings WHERE t_meetings.istatus > 0 and t_meetings.iroomid = ?          AND  ( date_format(t_meetings.sdate  ,\'%Y-%m-%d\')  >= ? and date_format(t_meetings.edate,\'%Y-%m-%d\')  <= ? ) order by t_meetings.sdate desc");
        t_meetingsRowSet.setTableName("t_meetings");
        t_meetingsRowSet_query.setDataSourceName("java:comp/env/jdbc/roomarrange_MySQL");
        t_meetingsRowSet_query.setCommand("SELECT ALL t_meetings.i_id, t_meetings.sdate, t_meetings.stime, t_meetings.edate, t_meetings.etime, t_meetings.cname, t_meetings.iroomid, t_meetings.ihost, t_meetings.cinitdept, t_meetings.cabstract, t_meetings.copinion, t_meetings.cnotice, t_meetings.inetdown, t_meetings.ivideo, t_meetings.iusrid, t_meetings.iconfirmid, t_meetings.istatus  FROM t_meetings WHERE t_meetings.istatus > 0 and t_meetings.iusrid = ?          AND  ( date_format(t_meetings.sdate  ,\'%Y-%m-%d\')  >= ? and date_format(t_meetings.edate,\'%Y-%m-%d\')  <= ? ) order by t_meetings.sdate desc");
        t_meetingsRowSet_query.setTableName("t_meetings");
        v_usrRowSet.setDataSourceName("java:comp/env/jdbc/roomarrange_MySQL");
        v_usrRowSet.setCommand("SELECT * FROM v_usr");
        v_usrRowSet.setTableName("v_usr");
        t_statusRowSet.setDataSourceName("java:comp/env/jdbc/roomarrange_MySQL");
        t_statusRowSet.setCommand("SELECT * FROM t_status");
        t_statusRowSet.setTableName("t_status");
        v_usrListA.setDataSourceName("java:comp/env/jdbc/roomarrange_MySQL");
        v_usrListA.setCommand("SELECT * FROM v_usr where igrpid = ?");
        v_usrListA.setTableName("v_usr");
        v_attendeeRowSet.setDataSourceName("java:comp/env/jdbc/roomarrange_MySQL");
        v_attendeeRowSet.setCommand("SELECT * FROM v_attendee where cmeetingid=? and igrpsort=1");
        v_attendeeRowSet.setTableName("v_attendee");
        v_meetingsRowSet.setDataSourceName("java:comp/env/jdbc/roomarrange_MySQL");
        v_meetingsRowSet.setCommand("SELECT ALL v_meetings.i_id, v_meetings.sdate, v_meetings.edate, v_meetings.cname, v_meetings.roomname, v_meetings.deptname, v_meetings.hostname, v_meetings.cabstract,v_meetings.copinion, v_meetings.cnotice, v_meetings.inetdown, v_meetings.ivideo, v_meetings.iusrid, v_meetings.cstatus  FROM v_meetings where v_meetings.iusrid = ?  AND  ( date_format(v_meetings.sdate  ,\'%Y-%m-%d\')  >= ? and date_format(v_meetings.edate,\'%Y-%m-%d\')  <= ? ) ");
        v_meetingsRowSet.setTableName("v_meetings");
        v_meetingsRowSet_confirm.setDataSourceName("java:comp/env/jdbc/roomarrange_MySQL");
        v_meetingsRowSet_confirm.setCommand("SELECT ALL v_meetings.i_id, v_meetings.sdate, v_meetings.edate, v_meetings.cname, v_meetings.roomname, v_meetings.deptname, v_meetings.hostname, v_meetings.cabstract,v_meetings.copinion, v_meetings.cnotice, v_meetings.inetdown, v_meetings.ivideo, v_meetings.iusrid, v_meetings.cstatus  FROM v_meetings where v_meetings.iconfirmid = ?  AND  ( date_format(v_meetings.sdate  ,\'%Y-%m-%d\')  >= ? and date_format(v_meetings.edate,\'%Y-%m-%d\')  <= ? ) ");
        v_meetingsRowSet_confirm.setTableName("v_meetings");
        v_meetingsRowSet_needconfirm.setDataSourceName("java:comp/env/jdbc/roomarrange_MySQL");
        v_meetingsRowSet_needconfirm.setCommand("SELECT ALL v_meetings.i_id, v_meetings.sdate, v_meetings.edate, v_meetings.cname, v_meetings.roomname, v_meetings.deptname, v_meetings.hostname, v_meetings.cabstract,v_meetings.copinion, v_meetings.cnotice, v_meetings.inetdown, v_meetings.ivideo, v_meetings.iusrid, v_meetings.cstatus  FROM v_meetings where v_meetings.igrpid = ?  AND (iconfirmid is null or iconfirmid=0 ) ");
        v_meetingsRowSet_needconfirm.setTableName("v_meetings");
        t_roomsetRowSet_vedio.setDataSourceName("java:comp/env/jdbc/roomarrange_MySQL");
        t_roomsetRowSet_vedio.setCommand("SELECT * FROM roomarrange.t_roomset where ivideo=1");
        t_roomsetRowSet_vedio.setTableName("t_roomset");
        t_roomsetRS_workspace.setDataSourceName("java:comp/env/jdbc/roomarrange_MySQL");
        t_roomsetRS_workspace.setCommand("SELECT * FROM roomarrange.t_roomset where i_bj > 3 ");
        t_roomsetRS_workspace.setTableName("t_roomset");
        v_worksRowSet.setDataSourceName("java:comp/env/jdbc/roomarrange_MySQL");
        v_worksRowSet.setCommand("SELECT * FROM roomarrange.v_works where istatus > 0 and iroomid = ? AND  ( date_format(sdate  ,\'%Y-%m-%d\')  >= ? and date_format(edate,\'%Y-%m-%d\')  <= ? ) order by sdate desc");
        v_worksRowSet.setTableName("v_works");
        v_worksRowSet2.setDataSourceName("java:comp/env/jdbc/roomarrange_MySQL");
        v_worksRowSet2.setCommand("SELECT * FROM roomarrange.v_works where istatus > 0 and iroomid = ? AND  ( date_format(sdate  ,\'%Y-%m-%d\')  >= ? and date_format(edate,\'%Y-%m-%d\')  <= ? ) and cinitdept = ?  order by sdate desc");
        v_worksRowSet2.setTableName("v_works");
        t_roomsetRowSet_wrkspc4.setDataSourceName("java:comp/env/jdbc/roomarrange_MySQL");
        t_roomsetRowSet_wrkspc4.setCommand("SELECT * FROM roomarrange.t_roomset where i_bj=4");
        t_roomsetRowSet_wrkspc4.setTableName("t_roomset");
        v_worksRowSet_byUser.setDataSourceName("java:comp/env/jdbc/roomarrange_MySQL");
        v_worksRowSet_byUser.setCommand("SELECT * FROM roomarrange.v_works where iusrid = ?  AND  ( date_format(sdate  ,\'%Y-%m-%d\')  >= ? and date_format(edate,\'%Y-%m-%d\')  <= ? ) ");
        v_worksRowSet_byUser.setTableName("v_works");
        v_worksRowSet_confirm.setDataSourceName("java:comp/env/jdbc/roomarrange_MySQL");
        v_worksRowSet_confirm.setCommand("SELECT * FROM roomarrange.v_works where iconfirmid = ?  AND  ( date_format(sdate  ,\'%Y-%m-%d\')  >= ? and date_format(edate,\'%Y-%m-%d\')  <= ? ) ");
        v_worksRowSet_confirm.setTableName("v_works");
        v_worksRowSet_needconfirm.setDataSourceName("java:comp/env/jdbc/roomarrange_MySQL");
        v_worksRowSet_needconfirm.setCommand("SELECT * FROM roomarrange.v_works where iconfirmbygrpid = ?  AND (iconfirmid is null or iconfirmid=0 ) ");
        v_worksRowSet_needconfirm.setTableName("v_works");
        v_worksRowSet_forPrnt.setDataSourceName("java:comp/env/jdbc/roomarrange_MySQL");
        v_worksRowSet_forPrnt.setCommand("SELECT * FROM roomarrange.v_works where sdate > now() and iroomsort = ? order by sdate");
        v_worksRowSet_forPrnt.setTableName("v_works");
        t_serviceRowSet.setDataSourceName("java:comp/env/jdbc/roomarrange_MySQL");
        t_serviceRowSet.setCommand("SELECT * FROM t_service");
        t_serviceRowSet.setTableName("t_service");
        t_hardwareRowSet.setDataSourceName("java:comp/env/jdbc/roomarrange_MySQL");
        t_hardwareRowSet.setCommand("SELECT * FROM t_hardware");
        t_hardwareRowSet.setTableName("t_hardware");
        t_worksRowSet.setDataSourceName("java:comp/env/jdbc/roomarrange_MySQL");
        t_worksRowSet.setCommand("SELECT * FROM t_works where istatus=5 and iroomid=19 and ( date_format(sdate  ,\'%Y-%m-%d\')  >= ? and date_format(edate,\'%Y-%m-%d\')  <= ? ) order by sdate desc ");
        t_worksRowSet.setTableName("t_works");
    }
    private int iusrid;
    private String spwd;
    private int iroomid;
    private String sSdate,sEdate;
    private String sUUID;
    private String sMtName;
    private int iMtHost;
    private int iMtInitdept;
    private String sMtAbstract;
    private String sMtNotice;
    private String sTip;
    private String sRef;
    private String sRefMtId;
    private CachedRowSetXImpl t_usrsetRowSet = new CachedRowSetXImpl();
    private String sRealName;
    private String sApp;
    private meetings mts;
    private int iRowCount;
    public CachedRowSetXImpl getT_usrsetRowSet() {
        return t_usrsetRowSet;
    }

    public void setT_usrsetRowSet(CachedRowSetXImpl crsxi) {
        this.t_usrsetRowSet = crsxi;
    }
    private CachedRowSetXImpl t_grpsetRowSet = new CachedRowSetXImpl();

    public CachedRowSetXImpl getT_grpsetRowSet() {
        return t_grpsetRowSet;
    }

    public void setT_grpsetRowSet(CachedRowSetXImpl crsxi) {
        this.t_grpsetRowSet = crsxi;
    }
    private CachedRowSetXImpl t_roomsetRowSet = new CachedRowSetXImpl();

    public CachedRowSetXImpl getT_roomsetRowSet() {
        return t_roomsetRowSet;
    }

    public void setT_roomsetRowSet(CachedRowSetXImpl crsxi) {
        this.t_roomsetRowSet = crsxi;
    }
    private CachedRowSetXImpl t_grpsortRowSet = new CachedRowSetXImpl();

    public CachedRowSetXImpl getT_grpsortRowSet() {
        return t_grpsortRowSet;
    }

    public void setT_grpsortRowSet(CachedRowSetXImpl crsxi) {
        this.t_grpsortRowSet = crsxi;
    }
    private CachedRowSetXImpl t_grpusrsRowSet = new CachedRowSetXImpl();

    public CachedRowSetXImpl getT_grpusrsRowSet() {
        return t_grpusrsRowSet;
    }

    public void setT_grpusrsRowSet(CachedRowSetXImpl crsxi) {
        this.t_grpusrsRowSet = crsxi;
    }
    private CachedRowSetXImpl v_grpusrsRowSet = new CachedRowSetXImpl();

    public CachedRowSetXImpl getV_grpusrsRowSet() {
        return v_grpusrsRowSet;
    }

    public void setV_grpusrsRowSet(CachedRowSetXImpl crsxi) {
        this.v_grpusrsRowSet = crsxi;
    }
    private CachedRowSetXImpl t_grpusrsRowSet1 = new CachedRowSetXImpl();

    public CachedRowSetXImpl getT_grpusrsRowSet1() {
        return t_grpusrsRowSet1;
    }

    public void setT_grpusrsRowSet1(CachedRowSetXImpl crsxi) {
        this.t_grpusrsRowSet1 = crsxi;
    }
    private CachedRowSetXImpl t_roomsortRowSet = new CachedRowSetXImpl();

    public CachedRowSetXImpl getT_roomsortRowSet() {
        return t_roomsortRowSet;
    }

    public void setT_roomsortRowSet(CachedRowSetXImpl crsxi) {
        this.t_roomsortRowSet = crsxi;
    }
    private CachedRowSetXImpl t_grpsetRowSet1 = new CachedRowSetXImpl();

    public CachedRowSetXImpl getT_grpsetRowSet1() {
        return t_grpsetRowSet1;
    }

    public void setT_grpsetRowSet1(CachedRowSetXImpl crsxi) {
        this.t_grpsetRowSet1 = crsxi;
    }
    private CachedRowSetXImpl t_meetingsRowSet = new CachedRowSetXImpl();

    public CachedRowSetXImpl getT_meetingsRowSet() {
        return t_meetingsRowSet;
    }

    public void setT_meetingsRowSet(CachedRowSetXImpl crsxi) {
        this.t_meetingsRowSet = crsxi;
    }
    private CachedRowSetXImpl t_meetingsRowSet_query = new CachedRowSetXImpl();

    public CachedRowSetXImpl getT_meetingsRowSet_query() {
        return t_meetingsRowSet_query;
    }

    public void setT_meetingsRowSet_query(CachedRowSetXImpl crsxi) {
        this.t_meetingsRowSet_query = crsxi;
    }
    private CachedRowSetXImpl v_usrRowSet = new CachedRowSetXImpl();

    public CachedRowSetXImpl getV_usrRowSet() {
        return v_usrRowSet;
    }

    public void setV_usrRowSet(CachedRowSetXImpl crsxi) {
        this.v_usrRowSet = crsxi;
    }
    private CachedRowSetXImpl t_statusRowSet = new CachedRowSetXImpl();

    public CachedRowSetXImpl getT_statusRowSet() {
        return t_statusRowSet;
    }

    public void setT_statusRowSet(CachedRowSetXImpl crsxi) {
        this.t_statusRowSet = crsxi;
    }
    private CachedRowSetXImpl v_usrListA = new CachedRowSetXImpl();

    public CachedRowSetXImpl getV_usrListA() {
        return v_usrListA;
    }

    public void setV_usrListA(CachedRowSetXImpl crsxi) {
        this.v_usrListA = crsxi;
    }
    private CachedRowSetXImpl v_attendeeRowSet = new CachedRowSetXImpl();

    public CachedRowSetXImpl getV_attendeeRowSet() {
        return v_attendeeRowSet;
    }

    public void setV_attendeeRowSet(CachedRowSetXImpl crsxi) {
        this.v_attendeeRowSet = crsxi;
    }
    private CachedRowSetXImpl v_meetingsRowSet = new CachedRowSetXImpl();

    public CachedRowSetXImpl getV_meetingsRowSet() {
        return v_meetingsRowSet;
    }

    public void setV_meetingsRowSet(CachedRowSetXImpl crsxi) {
        this.v_meetingsRowSet = crsxi;
    }
    private CachedRowSetXImpl v_meetingsRowSet_confirm = new CachedRowSetXImpl();

    public CachedRowSetXImpl getV_meetingsRowSet_confirm() {
        return v_meetingsRowSet_confirm;
    }

    public void setV_meetingsRowSet_confirm(CachedRowSetXImpl crsxi) {
        this.v_meetingsRowSet_confirm = crsxi;
    }
    private CachedRowSetXImpl v_meetingsRowSet_needconfirm = new CachedRowSetXImpl();

    public CachedRowSetXImpl getV_meetingsRowSet_needconfirm() {
        return v_meetingsRowSet_needconfirm;
    }

    public void setV_meetingsRowSet_needconfirm(CachedRowSetXImpl crsxi) {
        this.v_meetingsRowSet_needconfirm = crsxi;
    }
    private CachedRowSetXImpl t_roomsetRowSet_vedio = new CachedRowSetXImpl();

    public CachedRowSetXImpl getT_roomsetRowSet_vedio() {
        return t_roomsetRowSet_vedio;
    }

    public void setT_roomsetRowSet_vedio(CachedRowSetXImpl crsxi) {
        this.t_roomsetRowSet_vedio = crsxi;
    }
    private CachedRowSetXImpl t_roomsetRS_workspace = new CachedRowSetXImpl();

    public CachedRowSetXImpl getT_roomsetRS_workspace() {
        return t_roomsetRS_workspace;
    }

    public void setT_roomsetRS_workspace(CachedRowSetXImpl crsxi) {
        this.t_roomsetRS_workspace = crsxi;
    }
    private CachedRowSetXImpl v_worksRowSet = new CachedRowSetXImpl();

    public CachedRowSetXImpl getV_worksRowSet() {
        return v_worksRowSet;
    }

    public void setV_worksRowSet(CachedRowSetXImpl crsxi) {
        this.v_worksRowSet = crsxi;
    }
    private CachedRowSetXImpl v_worksRowSet2 = new CachedRowSetXImpl();

    public CachedRowSetXImpl getV_worksRowSet2() {
        return v_worksRowSet2;
    }

    public void setV_worksRowSet2(CachedRowSetXImpl crsxi) {
        this.v_worksRowSet2 = crsxi;
    }

    private CachedRowSetXImpl t_roomsetRowSet_wrkspc4 = new CachedRowSetXImpl();

    public CachedRowSetXImpl getT_roomsetRowSet_wrkspc4() {
        return t_roomsetRowSet_wrkspc4;
    }

    public void setT_roomsetRowSet_wrkspc4(CachedRowSetXImpl crsxi) {
        this.t_roomsetRowSet_wrkspc4 = crsxi;
    }
    private CachedRowSetXImpl v_worksRowSet_byUser = new CachedRowSetXImpl();

    public CachedRowSetXImpl getV_worksRowSet_byUser() {
        return v_worksRowSet_byUser;
    }

    public void setV_worksRowSet_byUser(CachedRowSetXImpl crsxi) {
        this.v_worksRowSet_byUser = crsxi;
    }
    private CachedRowSetXImpl v_worksRowSet_confirm = new CachedRowSetXImpl();

    public CachedRowSetXImpl getV_worksRowSet_confirm() {
        return v_worksRowSet_confirm;
    }

    public void setV_worksRowSet_confirm(CachedRowSetXImpl crsxi) {
        this.v_worksRowSet_confirm = crsxi;
    }
    private CachedRowSetXImpl v_worksRowSet_needconfirm = new CachedRowSetXImpl();

    public CachedRowSetXImpl getV_worksRowSet_needconfirm() {
        return v_worksRowSet_needconfirm;
    }

    public void setV_worksRowSet_needconfirm(CachedRowSetXImpl crsxi) {
        this.v_worksRowSet_needconfirm = crsxi;
    }
    private CachedRowSetXImpl v_worksRowSet_forPrnt = new CachedRowSetXImpl();

    public CachedRowSetXImpl getV_worksRowSet_forPrnt() {
        return v_worksRowSet_forPrnt;
    }

    public void setV_worksRowSet_forPrnt(CachedRowSetXImpl crsxi) {
        this.v_worksRowSet_forPrnt = crsxi;
    }
    private CachedRowSetXImpl t_serviceRowSet = new CachedRowSetXImpl();

    public CachedRowSetXImpl getT_serviceRowSet() {
        return t_serviceRowSet;
    }

    public void setT_serviceRowSet(CachedRowSetXImpl crsxi) {
        this.t_serviceRowSet = crsxi;
    }
    private CachedRowSetXImpl t_hardwareRowSet = new CachedRowSetXImpl();

    public CachedRowSetXImpl getT_hardwareRowSet() {
        return t_hardwareRowSet;
    }

    public void setT_hardwareRowSet(CachedRowSetXImpl crsxi) {
        this.t_hardwareRowSet = crsxi;
    }
    private CachedRowSetXImpl t_worksRowSet = new CachedRowSetXImpl();

    public CachedRowSetXImpl getT_worksRowSet() {
        return t_worksRowSet;
    }

    public void setT_worksRowSet(CachedRowSetXImpl crsxi) {
        this.t_worksRowSet = crsxi;
    }

    // </editor-fold>

    /**
     * <p>Construct a new session data bean instance.</p>
     */
    public SessionBean1() {
    }

    /**
     * <p>This method is called when this bean is initially added to
     * session scope.  Typically, this occurs as a result of evaluating
     * a value binding or method binding expression, which utilizes the
     * managed bean facility to instantiate this bean and store it into
     * session scope.</p>
     * 
     * <p>You may customize this method to initialize and cache data values
     * or resources that are required for the lifetime of a particular
     * user session.</p>
     */
    @Override
    public void init() {
        // Perform initializations inherited from our superclass
        super.init();
        // Perform application initialization that must complete
        // *before* managed components are initialized
        // TODO - add your own initialiation code here
        
        // <editor-fold defaultstate="collapsed" desc="Managed Component Initialization">
        // Initialize automatically managed components
        // *Note* - this logic should NOT be modified
        try {
            _init();
        } catch (Exception e) {
            log("SessionBean1 Initialization Failure", e);
            throw e instanceof FacesException ? (FacesException) e: new FacesException(e);
        }
        
        // </editor-fold>
        // Perform application initialization that must complete
        // *after* managed components are initialized
        // TODO - add your own initialization code here
    }

    /**
     * <p>This method is called when the session containing it is about to be
     * passivated.  Typically, this occurs in a distributed servlet container
     * when the session is about to be transferred to a different
     * container instance, after which the <code>activate()</code> method
     * will be called to indicate that the transfer is complete.</p>
     * 
     * <p>You may customize this method to release references to session data
     * or resources that can not be serialized with the session itself.</p>
     */
    @Override
    public void passivate() {
    }

    /**
     * <p>This method is called when the session containing it was
     * reactivated.</p>
     * 
     * <p>You may customize this method to reacquire references to session
     * data or resources that could not be serialized with the
     * session itself.</p>
     */
    @Override
    public void activate() {
    }

    /**
     * <p>This method is called when this bean is removed from
     * session scope.  Typically, this occurs as a result of
     * the session timing out or being terminated by the application.</p>
     * 
     * <p>You may customize this method to clean up resources allocated
     * during the execution of the <code>init()</code> method, or
     * at any later time during the lifetime of the application.</p>
     */
    @Override
    public void destroy() {
    }
    
    /**
     * <p>Return a reference to the scoped data bean.</p>
     *
     * @return reference to the scoped data bean
     */
    protected ApplicationBean1 getApplicationBean1() {
        return (ApplicationBean1) getBean("ApplicationBean1");
    }

    /**
     * @return the iusrid
     */
    public int getIusrid() {
        return iusrid;
    }

    /**
     * @param iusrid the iusrid to set
     */
    public void setIusrid(int iusrid) {
        this.iusrid = iusrid;
    }

    /**
     * @return the spwd
     */
    public String getSpwd() {
        return spwd;
    }

    /**
     * @param spwd the spwd to set
     */
    public void setSpwd(String spwd) {
        this.spwd = spwd;
    }

    /**
     * @return the imeetingid
     */
    public int getIroomid() {
        return iroomid;
    }

    /**
     * @param imeetingid the imeetingid to set
     */
    public void setIroomid(int imeetingid) {
        this.iroomid = imeetingid;
    }

    /**
     * @return the sSdate
     */
    public String getSSdate() {
        return sSdate;
    }

    /**
     * @param sSdate the sSdate to set
     */
    public void setSSdate(String sSdate) {
        this.sSdate = sSdate;
    }

    /**
     * @return the sEdate
     */
    public String getSEdate() {
        return sEdate;
    }

    /**
     * @param sEdate the sEdate to set
     */
    public void setSEdate(String sEdate) {
        this.sEdate = sEdate;
    }

    /**
     * @return the sUUID
     */
    public String getSUUID() {
        return sUUID;
    }

    /**
     * @param sUUID the sUUID to set
     */
    public void setSUUID(String sUUID) {
        this.sUUID = sUUID;
    }

    /**
     * @return the sMtName
     */
    public String getSMtName() {
        return sMtName;
    }

    /**
     * @param sMtName the sMtName to set
     */
    public void setSMtName(String sMtName) {
        this.sMtName = sMtName;
    }

    /**
     * @return the iMtHost
     */
    public int getIMtHost() {
        return iMtHost;
    }

    /**
     * @param iMtHost the iMtHost to set
     */
    public void setIMtHost(int iMtHost) {
        this.iMtHost = iMtHost;
    }

    /**
     * @return the iMtInitdept
     */
    public int getIMtInitdept() {
        return iMtInitdept;
    }

    /**
     * @param iMtInitdept the iMtInitdept to set
     */
    public void setIMtInitdept(int iMtInitdept) {
        this.iMtInitdept = iMtInitdept;
    }

    /**
     * @return the sMtAbstract
     */
    public String getSMtAbstract() {
        return sMtAbstract;
    }

    /**
     * @param sMtAbstract the sMtAbstract to set
     */
    public void setSMtAbstract(String sMtAbstract) {
        this.sMtAbstract = sMtAbstract;
    }

    /**
     * @return the sMtNotice
     */
    public String getSMtNotice() {
        return sMtNotice;
    }

    /**
     * @param sMtNotice the sMtNotice to set
     */
    public void setSMtNotice(String sMtNotice) {
        this.sMtNotice = sMtNotice;
    }

    /**
     * @return the sTip
     */
    public String getSTip() {
        return sTip;
    }

    /**
     * @param sTip the sTip to set
     */
    public void setSTip(String sTip) {
        this.sTip = sTip;
    }

    /**
     * @return the sRef
     */
    public String getSRef() {
        return sRef;
    }

    /**
     * @param sRef the sRef to set
     */
    public void setSRef(String sRef) {
        this.sRef = sRef;
    }

    /**
     * @return the sRefMtId
     */
    public String getSRefMtId() {
        return sRefMtId;
    }

    /**
     * @param sRefMtId the sRefMtId to set
     */
    public void setSRefMtId(String sRefMtId) {
        this.sRefMtId = sRefMtId;
    }

    /**
     * @return the sRealName
     */
    public String getSRealName() {
        return sRealName;
    }

    /**
     * @param sRealName the sRealName to set
     */
    public void setSRealName(String sRealName) {
        this.sRealName = sRealName;
    }

    /**
     * @return the sApp
     */
    public String getSApp() {
        return sApp;
    }

    /**
     * @param sApp the sApp to set
     */
    public void setSApp(String sApp) {
        this.sApp = sApp;
    }

    /**
     * @return the mts
     */
    public meetings getMts() {
        return mts;
    }

    /**
     * @param mts the mts to set
     */
    public void setMts(meetings mts) {
        this.mts = mts;
    }

}
